package com.ruoyi.oa.mapper;

import com.ruoyi.oa.domain.OaHoliday;
import com.ruoyi.oa.domain.vo.OaHolidayVo;
import com.ruoyi.common.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Select;

/**
 * 假期Mapper接口
 *
 * @author ruoyi
 * @date 2023-07-12
 */
public interface OaHolidayMapper extends BaseMapperPlus<OaHolidayMapper, OaHoliday, OaHolidayVo> {

    @Select("SELECT * \n" +
        "FROM oa_holiday \n" +
        "WHERE DATE( holiday_date ) =#{date} and type !='3' limit 1")
    OaHoliday selectIsHoliday(String date);

}
